sql 子查询带有条件怎么改成左连接答:SELECT A.AS_CODE ,A.AS_PACTNAME ,A.AS_STADATE ,A.AS_ENDDATE ,B.AR_SUMTIME ,B.AR_YQTIME ,B.AR_TPTIME ,COUNT(A.AD_CODE), COUNT(CASE WHEN C.ED_DOWNSTATE=1 THEN C.EBCOMPANYCODE END), COUNT(CASE WHEN C.ED_DOWNSTATE=0 THEN C.EBCOMPANYCODE END), COUNT(CASE...